package io.finer.erp.jeecg.bas.mapper;

import java.util.List;

import org.apache.ibatis.annotations.Select;

import io.finer.erp.jeecg.bas.entity.ErpSysRole;
import io.lettuce.core.dynamic.annotation.Param;

public interface ErpSysMapper {

	@Select("select * FROM sys_role WHERE id in (select sur.role_id from sys_user_role sur LEFT JOIN sys_role sr on sur.role_id=sr.id WHERE sur.user_id=#{userId})")
	List<ErpSysRole> getRoleByUserId(@Param("userId")String userId);
}
